package com.clkj.xiuzheng.dao.shangcheng;

import com.clkj.xiuzheng.pojo.shangcheng.ProductFormat;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;


@Repository
public interface ScProductformatMapper extends Mapper<ProductFormat>,MySqlMapper<ProductFormat> {
    @Select("select sum(product_num) from t_xz_productFormat where product_id = #{id}")
    Integer selectCountByProductId(@Param("id") Integer id);
    @Select("select sum(product_sales) from t_xz_productFormat where product_id = #{id}")
    Integer selectSaleByProductId(Integer id);
}
